Line and Clustered column Visual 16

Visual 3: Line and Clustered column Visual = Sales Per Month/YoY/GPM by Year and Month

Fields Tab

Ø  Shared Axis: MonthNameLong/Year

Ø  Column Values: Sales Per Month

Ø  Line Values: YOY%/GPM

Format Tab

Ø  General: X Position = 207, Y Position = 382, Width = 517, Height 338

Ø  Legend: On, Position = Top, Title = On, Color = #605E5C, font family = Segoe UI, Text size = 10, Style = Markers Only

Ø  X Axis: Color = #605E5C, Text Size = 9, Font family = Segoe UI, Minimum category width = 20, Maximum Size = 25%, Inner Padding = 20%, Concatenate labels = On, Title = Off

Ø  Y Axis : Position = Left, Scale Type = Linear, Start = Auto, End = Auto, Color = #12239E, Text size = 9, Font family = Segoe UI Bold, Display Units = Auto, Value Decimal places = Auto, Title = Off,  Secondary = On, Align zeros = off, Y Axis (line): Position = Right, Start = Auto, End = Auto, Scale type = Linear, color = #BF9D02, text size = 9, font family = Segoe UI (Bold), Display units = Auto, Title = Off

Ø  Data Colors, YoY% = #E66C37, GPM = #D9B300, Default Color = #12239E

Ø  Data Label = On, Color = #605E5C, Display Units = Auto, Value Decimal places = Auto, Orientation = Horizontal, Position = Auto, Text Size = 9, Font Family = Segoe UI, Show Background = On, Background Color = #FFFFFF, Transparency = 30%

Ø  Shapes: Shade area = On, Stroke width = 3, Join Type = Round, Line Style = Solid, Show marker = Off

Ø  Title = On, Title Text = Month/Year, Word wrap = On, font color = #000000, Background color = #CCCCCC, Alignment = Center, Text Size = 14, Font Family = Segoe UI Bold

Ø  Background: On, color = #FFFFFFF, Transparency = 0%

Ø  Border: Color = #E6E6E6, Radius = 0

Ø  Shadow: Off

Ø  Tooltip = On, Type = Report Page, Page = Auto, Label Text color = #C8C8C8, Value text color = #EAEAEA, Text size = 9, Font family = Segoe UI, Background color = #333333, Transparency = 5%

Ø  Visual header = On, background color = #FFFFFF, Boarder = #FFFFFF, Transparency = 0%, Icon color = #333333, Visual information icon = On, Visual warning icon = On, Drill on drop down = On, Drill up icon = On, Drill down icon = On, Show next level icon = On, Expand to next level icon = On, Pin icon = On, Focus mode icon = On, Filter icon = On, See data layout icon = On, More Options icon = On

Use the following step by step Gif to create the visual

Step 1


Step 2


Step 3


Step 4


Step 5






How to create line and clustered column chart in power bi

https://www.youtube.com/watch?v=2d1JhcrhhGo